Formatting / adding data to field

[rishir]

Hi if I have

1108000
1104006
1702003

and I want it to be

c:\data\1108000.jpg
c:\data\1104006.jpg
c:\data\1702003.jpg

How can I do this?

Thank you.

 

[JLGWhiz]

The quick and easy way is to open File Explorer, click on Home.New Folder, then type in your folder name as "C:\data" without the quote marks, then Save you jpg file to that directory.

 

[rishir]

The quick and easy way is to open File Explorer, click on Home.New Folder, then type in your folder name as "C:\data" without the quote marks, then Save you jpg file to that directory.

Thanks for replying. I’m not trying to create a folder.

I need the field to represent what I typed in the question. It’s being used for an import to a database which will reference that field to find the file location.

i’m basically trying to use the field “A” and create a new field “B” adding text before and after field “A”

 

[cooper645]

="c:\data\"&A1&".jpg"

 

[JLGWhiz]

Well it helps if you fully explain what you are trying to do up front so w3e don't have to guess at it., But being that you are a new member, I will overlook that.

You can concatenate cell values via formula to create a cell with the combined valu3es which you can then use as you reference.

TestBase.xlsm
	A	B	C
1	1108000
2	C:data\
3	C:data\1108000.jpg
4
5
6
Sheet1

Cell Formulas
Range	Formula
A3	A3	=A2&A1&".jpg"

concatenate different cell values to a single cell then use that concatenated cell value as your Import/Export reference.

 

[rishir]

Well it helps if you fully explain what you are trying to do up front so w3e don't have to guess at it., But being that you are a new member, I will overlook that.

You can concatenate cell values via formula to create a cell with the combined valu3es which you can then use as you reference.

TestBase.xlsm
	A	B	C
1	1108000
2	C:data\
3	C:data\1108000.jpg
4
5
6
Sheet1

Cell Formulas
Range	Formula
A3	A3	=A2&A1&".jpg"

concatenate different cell values to a single cell then use that concatenated cell value as your Import/Export reference.

Sorry for the confusion, this is perfect! Thank you for your assistance

 

[JLGWhiz]

You're welcome,
regards, JLG